<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<?php
$connect = mysql_connect("localhost","nguyentr_usr","t9exm5GKV3Ub");
$selectdb = mysql_select_db("nguyentr_web");


function url_friend($str) {
		$str = preg_replace("/(à|á|ạ|ả|ã|â|ầ|ấ|ậ|ẩ|ẫ|ă|ằ|ắ|ặ|ẳ|ẵ)/", 'a', $str);
		$str = preg_replace("/(è|é|ẹ|ẻ|ẽ|ê|ề|ế|ệ|ể|ễ)/", 'e', $str);
		$str = preg_replace("/(ì|í|ị|ỉ|ĩ)/", 'i', $str);
		$str = preg_replace("/(ò|ó|ọ|ỏ|õ|ô|ồ|ố|ộ|ổ|ỗ|ơ|ờ|ớ|ợ|ở|ỡ)/", 'o', $str);
		$str = preg_replace("/(ù|ú|ụ|ủ|ũ|ư|ừ|ứ|ự|ử|ữ)/", 'u', $str);
		$str = preg_replace("/(ỳ|ý|ỵ|ỷ|ỹ)/", 'y', $str);
		$str = preg_replace("/(đ)/", 'd', $str);
		$str = preg_replace("/(À|Á|Ạ|Ả|Ã|Â|Ầ|Ấ|Ậ|Ẩ|Ẫ|Ă|Ằ|Ắ|Ặ|Ẳ|Ẵ)/", 'A', $str);
		$str = preg_replace("/(È|É|Ẹ|Ẻ|Ẽ|Ê|Ề|Ế|Ệ|Ể|Ễ)/", 'E', $str);
		$str = preg_replace("/(Ì|Í|Ị|Ỉ|Ĩ)/", 'I', $str);
		$str = preg_replace("/(Ò|Ó|Ọ|Ỏ|Õ|Ô|Ồ|Ố|Ộ|Ổ|Ỗ|Ơ|Ờ|Ớ|Ợ|Ở|Ỡ)/", 'O', $str);
		$str = preg_replace("/(Ù|Ú|Ụ|Ủ|Ũ|Ư|Ừ|Ứ|Ự|Ử|Ữ)/", 'U', $str);
		$str = preg_replace("/(Ỳ|Ý|Ỵ|Ỷ|Ỹ)/", 'Y', $str);
		$str = preg_replace("/(Đ)/", 'D', $str);
		$str = preg_replace("/(Ỳ|Ý|Ỵ|Ỷ|Ỹ)/", 'Y', $str);
		//$str = preg_replace("/(\:|\;|\`|\'|\"|\~|\!|\@|\#|\%|\^|\&|\*|\,|\/|\(|\)|\.)/", '', $str);
		//$str = str_replace("\\", "", $str);
		//$str = str_replace("$", "", $str);
		//$str = str_replace(" ", "-", $str);
		//$str = str_replace("--", "-", $str);
		//$str = str_replace("---", "-", $str);
		//$str = str_replace("----", "-", $str);
		$str = strtolower($str);
		return $str;
	}

//$str = "Cộng hòa xã hội chủ nghĩa việt nam";
$getsql = "select `ID`,`post_title` from ntt_posts limit 10";
$result = mysql_query($getsql);
while ($rows = mysql_fetch_array($result)){	
	//$sql_update = "update ntt_posts set post_name='".url_friend($rows["post_title"])."' where `ID`='".$rows["ID"]."'";
	echo $rows["post_title"];
	//echo url_friend($rows["post_title"]);
	//mysql_query($sql_update);
}
?>